Editing Package Definition

Edit the package definition under the Definition tab.

The Code Outline window displays information about the package including function, procedure, parameter, code body, etc. To show the Code Outline window, simply choose Edit -> Code Outline.

Note: Available only in Full Version.

Refresh the code outline.
Turn mouse over highlight on or off.
Show the code outline in a detail way.
Sort by type and name.
Expand the selected item.
Collapse the selected item.

The SQL statements for creating packages are CREATE PACKAGE. In practice, it is best to use a CREATE OR REPLACE statement. The general form of these statements follows.

      CREATE OR REPLACE 
      PACKAGE /*PACKAGE NAME*/ AS 
        /* TODO enter package declarations (types, exceptions, methods etc) here */ 
      end; 

Hint: To customize the view of the editor and find out more features for sql editing, see Editor View and More Features.